package com.thirdgroup.dao.impl;

import com.thirdgroup.dao.OrderPhoneSonDao;
import com.thirdgroup.dao.base.BaseDAO;
import com.thirdgroup.pojo.vo.OrderPhoneVo;

import java.util.List;

public class OrderPhoneSonDaomImpl extends BaseDAO<OrderPhoneVo> implements OrderPhoneSonDao {
    @Override
    public List<OrderPhoneVo> selects(String order) {
        String sql="select DISTINCT u.userPhone ,u.userPassword ,u.userStatus\n" +
                "from user_info u\n" +
                "where u.customerOrderID=?";
        Object[] params={order};
        return super.findAll(sql,params);
    }
}
